SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_GetNoticeByID]
    (
      @param_JOL_Bulletin_No INT
    )
AS 
    SELECT  JOL_Bulletin_No,
            JOL_Bulletin_Type,
            JOL_Bulletin_Title,
            JOL_Bulletin_Source,
            JOL_Bulletin_ClickNumber,
            JOL_Bulletin_Body,
            JOL_Bulletin_AddTime,
            JOL_Bulletin_AddUser,
            JOL_Bulletin_UpdateTime,
            JOL_Bulletin_UpdateUser,
            JOL_Bulletin_IsSetTop,
            JOL_Bulletin_SubType,
            JOL_Bulletin_ImageUrl
    FROM    dbo.JOL_Bulletin
    WHERE   JOL_Bulletin_No = @param_JOL_Bulletin_No
GO
